package guoanmaker.operator.business.repository;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;

import org.springframework.data.repository.query.Param;


import guoanmaker.operator.business.model.PersonalUser;
import guoanmaker.operator.business.model.ProviderBusiness;

public interface PersonalUserRepository extends  JpaRepository<PersonalUser, String>, JpaSpecificationExecutor<PersonalUser>{

	
	@Query("select count(u.id) from PersonalUser u")
	public Long  selectBycontId();
		

	@Query("select b from  PersonalUser b   where  b.username=:username ")
	public  List<PersonalUser> viewmerUchantinfo(@Param("username") String username);

}
